1.1.1 Application wide (on all places where possible)
F1 - Help
F5 - Refresh
1.1.2 Application desktop
Alt F1/F2 - skip between browsing tree/desktop
Shift Alt F1/F2 - skip from & hide/skip into & unhide tree browser
1.1.3 Browsing Tree
Tab - skip from tree -into-> desktop
Enter - open selected object
Ctrl Enter - design selected object
Del - drop object selected object
Ctrl X/C/V - transfer (if pasted into another db.)/clone (if pasted into the same db) object
same functionality provides tree drag&drop functionality
1.2 XLS like Table
F1 - help
F5 - refresh
F2 - edit
Ctrl A - select All
Ctrl X/C/V - cut/copy/paste
Alt F3/F3/Shift F3 find/find next/find prev ( Ctrl F = Alt F3 )
F4 - more...
1.2.1 SQL Data Table (extend XLS like Table)
* * *functions listed in popup menu
a - Autofilter
d - Design Table
w - Edit WHERE
u - Update Changes
* * * unlisted functions
F6 - selects line/s in which is located cursor
Esc - close window
Ctrl F12 - breaks loading of table data
Ctrl + Open Data Table Window (from browser) - opens table as is (in case of custom looking tables (function Save Table Options))
1.3. Query/Procedure editor
Alt q, r, p, l - switches between opened tabs (Query/Result/Parameters/pLan)
1.3.1 Editor
F1 - online T-SQL help + database hyperlink browser
(if keyword under cursor:
T-SQL command -> help
table name (reference) -> open, design, where open, generate column list
procedure/trigger/view/rule/default name -> design/execute*
Esc - write ahead
Ctrl A - select all
Ctrl Z/Y - undo/redo
Alt F3/F3/Shift F3 - find, find next, find prev
Tab/Shift Tab - indent/unindent selected lines
F4 - next error
Ctrl S - save
Ctrl F2 - toggle/remove bookmark
F2/Shift F2 - goto next/previous bookmark
Ctrl D - find ( like in DevStudio )
Ctrl E - execute (block if one selected, whole script else)
Ctrl G - goto line
Ctrl H - replace
Ctrl F - view column list of table under caret (with Shift ling column list is generated - try)
F5/Alt F5 - run/stop debug
F9 - set/remove breakpint
Ctrl B - edit breakpoints
F7 - run to cursor
F8 - step into
F11 - step over
1.3.2. Results
F4 goto error (like in msdev)
Ctrl A - select all
Ctrl S - save...
Ctrl C - copy
1.4. Reports
F5 - refresh
Del - removes table from relational model/removes selected columns from report
2. Popup Menus - a menu shown after right mouse click
2.1 Tree Browser
containts in popup menu whole application functionality.
2.2 List Of Usefull Functions
2.2.1. SQL Data Of Table
Related Table - shows records of chosen related table , related to selected records (...hope it't clear)
Field Chooser - option to specify subset of columns to be loaded as table.
Expand Column - tables having 1->N relation with our table, may be expanded to see "values" instead of FK's. Expand Column 'colname' on such FK column header will expand values into column.
Save Table Options - saves table layout. Next time the table is open by current user,
will be opened as is in time of save. Following options are saved:
- Sort Order
- Column Order ( it is possible to change column order by dragging selected columns)
- Sizes of columns ( or "default size" which is set by double-click-ing on the divider line in table header)
- Autofilters
- Column Expansion ( see Expand Column )
- Column list ( in case of some columns were not loaded . see Field Chooser )
Record Script - records all changes made in table into SQL script.
2.2.2. Query Editor
2.2.2.1 Editor
Replace - extensive replace
Colors... - defines colors of lexemes
Define Vocabulary - executes script in window to obtain results for custom lexeme set "User Defined". example : Select name from master..sysdatabases select name from master..systypes
2.2.2.2. Results
View In Table - views underlaying data of table in XLS like table (advantages : sort, find, save data into SQL table)
2.2.2.3. Browser
Alt+text -> find object
2.2.2.3.1. Data Tab
Filter... - for filter just used objects / object types
Script Data - scripts of data of table (including BLOB fields)
Select Count(*) - prints number of table lines into info line
2.2.2.3.2. Code Tab
View Help - views first comment in procedure (may be used as procedure help (and/or) description)
2.2.2.4. Relational Model
2.2.2.4.1. Table In Relational Model
View Table - open table designer for table
Open Table - views data of table
Add relation... - (just in downsized db.)
2.2.2.4.2 Relations In Relational Model ( just in downsized database)
Edit Relation
Delete Relation
2.2.2.4.3 All Other functions
Add Note/Add Free Text Note - adds notes into relational model (theese are saved vitw view. see View/Save)
Scale - scales relational model
Select - select table(s) just for case saving into relational view (see View/Save)
View - load/save/delete (often subset) view into relational model (maybe with notes)
2.2.2.5. sysprocesses table
Show Input Buffer - shows last commend executed by selected process
Send Message To Owners - sends "net send" with specified text to owner(s) of selected process(es)
Autorefresh... - starts autorefresh of window (table) with specified interval
2.2.2.6. Report designer
2.2.2.6.1. Upper (Relational Model) part
Add Table - containts list of related tables prepared to be opened
Read Table Comments / Hide Table Comments - wiews / hides comments to columns of table
2.2.2.6.2. Bottom Part
Open Graph - open graph viewing selected columns (at least 1 must be any numeric datatype and at least 1 must be non numeric)
Column Options - enables to set usefull options for selected column
Show Cursor Script... - generates T-SQL cursor script for designed query
note: popup menu containts function "View Data In Table" while opening over table results
-CCoffline_export_settings_file_name.tse - offline export to script
-CJdirectory - offline import
-debug - enables application debug features
5. SQLing server options - options residing in table SQLing..options of managed server
lines:
Don't rollback (in trigger) in nested transaction - if opt_int<>0 then Referential integrity triggers does not containts rollback tran.
Postupsize batch - opt_text=script to be executed after each upsize; opt_int=1
Save downsizes - opt_text=directory where downsizes will be automatically saved before each upsize. opt_int=1
6. Troubleshooting
Q:Table With All Cells eq null it loaded instead of data.
A:Under OLEDB is not possible load tables having more than one BLOB column. Use popupmenu/Field Chooser ... function to choose just nessesary fields.
Q: How can I see if all table data was loaded.
A: numbers in info line means : Actually Read Number Of Lines/select count(*)
Q: What Options to select while creating Primary Key.
A: Due to 2 types of supported relations, set "Primary Key" in "Index Type" field and check checkbox "Use As Primary Key ...", to avoid problems when changing relations (between trigger and constraint driven).
Q: How to print relational model ?
A: Open the map window (first button in relational model toolbar). With left mouse button held down select area to be printed and release the button. In Shown popuop menu select Print.
